Re: Driver.connect Timeout

As it turns out, I have been working on a solution that will allow
you to do just what you want.  My company has been running into a
problem when a database goes down, that the Driver hangs when trying
to create a connection.  In response, I added in a way to set the
socket timeout during connection creation.

You can set the timeout on the URL as follows:

jdbc:postgresql://host/database?timeout=5000

which would set a timeout of 5000 milliseconds.

I've attached the patch files.  They apply to the REL_7_4_1 tagged
files from the GBorg cvs repository.

Jeff


On Mon, 12 Jan 2004, Darin Ohashi wrote:

>
>  Is there some way to specify a timeout in the Driver.connect url?
>
>  MySQL allows one to do the following:
>
>  "jdbc:mysql://host/database?socketTimeout=5000"
>
>  We are having some stability problems with the machine running the
postgresql
>  server.  When some of our automated tests attempt to access the
database when
>  the machine is down, they hang trying to open the connection.
>

This was just recently brought up in this thread:
http://archives.postgresql.org/pgsql-jdbc/2004-01/msg00085.php

It has some mention of a Connection pool, but that is another problem.
I
took a quick look at the mysql source and they use reflection to
determine
if a 1.4 jvm is present and use the timeout in that case or throw an
Exception otherwise.

For the question of setSoTimeout they only do so once, but not knowing
how
their protocol works it is uncertain if they don't need to perform
multiple reads during connection setup or they are just punting on the
problem.

Kris Jurka